{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["MSU","MYP, MSS","Kärkilyönnit"],"read":"whole","date_system":"1900"}

{"sheet":"MSU","index":0,"n_rows":35,"n_cols":43,"rows_kept":35}
[null,"Robert Tallbacka",null,null,"13.2.1991   Alajärvi"]
[null,"SUPERPESIS",null,null,"Runkosarja",{"$nulls":3},"  Kärkilyönnit (KL),  pesänvälit",{"$nulls":6},"      Runkosarja TOP-30",{"$nulls":4},"Ylempi loppusarja",{"$nulls":6},"Ylempi loppusarja TOP-10",{"$nulls":4},"Play off, voitot, voittoprosentti",{"$nulls":4}," Arvo-ottelut",null,null,"      Mitalit"]
[null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","0 > 1","1 > 2","2 > 3","3 > k","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"Puolivälierät","Välierät","Pronssi","Finaalit",null,"IL","LL","hSM","K","H","P"]
[null,2008,"3.","KoU  2",null,"suomensarja"]
[null,2008,"10.","AA",null,"ykköspesis"]
[null,2009,"10.","AA  2",null,"suomensarja"]
[null,2009,"8.","AA",null,"ykköspesis"]
[null,2010,"9.","AA  2",null,"suomensarja"]
[null,2010,"2.","AA",null,"ykköspesis"]
[null,2011,"1.","AA",null,"ykköspesis"]
[null,2012]
[null,2013,"7.","AA  2",null,"suomensarja"]
[null,2013,"12.","HP-K",null,"ykköspesis"]
[null,2013,"12.","AA",11,0,4,2,39,1,21,13,4,{"v":0.5492,"d":"54.9 %"},{"$f":"PRODUCT(I14/N14)","v":71.01238164603059}]
[null,2014,"12.","Kiri",25,1,7,9,75,5,20,42,8,{"v":0.497,"d":"49.7 %"},{"$f":"PRODUCT(I15/N15)","v":150.90543259557344}]
[null,2015]
[null,2016,null,"KiPa",null,"halliturnaus"]
[null,2017,"8.","LieKi",null,"ykköspesis"]
[null,2017,"7.","KiPa",22,0,14,1,34,0,7,13,14,{"v":0.425,"d":"42.5 %"},80,{"$nulls":5},3,0,4,1,6,{"v":0.5,"d":"50.0 %"},{"$nulls":6},"0-3  ViVe"]
[null,"Yhteensä",null,null,{"$f":"SUM(E4:E19)","v":58},1,25,12,148,6,48,68,26,{"$f":"PRODUCT(I20/O20)","v":{"v":0.4901996272454655,"d":"49.0 %"}},{"$f":"SUM(O3:O19)","v":301.91781424160405},"0-0-0","0-0-0","0-0-0","0-0-0",null,{"$f":"SUM(U19)","v":3},0,4,1,6,{"v":0.5,"d":"50.0 %"},null,"0-0-0","0-0-0","0-0-0","0-0-0",null,"0/1","0/0","0/0","0/0",null,{"$f":"SUM(AL4:AL19)","v":0},0,0,0,0,0]
[{"$nulls":32},{"v":0,"d":"0.0 %"},{"v":0,"d":"0.0 %"},{"v":0,"d":"0.0 %"},{"v":0,"d":"0.0 %"}]
[null,"Pesispörssi",null,{"$f":"SUM(F20:H20)+((I20-F20-G20)/3)+(E20/3)+(AL20*25)+(AM20*25)+(AN20*10)+(AO20*25)+(AP20*20)+(AQ20*15)","v":{"v":97.99999999999999,"d":"98.0"}}]
[]
[null,"URA SUPERISSA",null,null,"OTT","KUN","LÖI","TOI","KL",null,"ka/L","ka/T","ka/KL","KL-%",null,"ENSIMMÄISET RUNKOSARJASSA",{"$nulls":16},"ENSIMMÄISET PUDOTUSPELEISSÄ",{"$nulls":4},"YLEISÖ"]
[null,"Runkosarja",null,null,{"$f":"PRODUCT(E20)","v":58},{"$f":"PRODUCT(F20)","v":1},{"$f":"PRODUCT(G20)","v":25},{"$f":"PRODUCT(H20)","v":12},{"$f":"PRODUCT(I20)","v":148},null,{"$f":"PRODUCT((F25+G25)/E25)","v":{"v":0.4482758620689655,"d":"0.45"}},{"$f":"PRODUCT(H25/E25)","v":{"v":0.20689655172413793,"d":"0.21"}},{"$f":"PRODUCT(I25/E25)","v":{"v":2.5517241379310347,"d":"2.55"}},{"$f":"PRODUCT(N20)","v":{"v":0.4901996272454655,"d":"49.0 %"}},{"$f":"PRODUCT(O20)","v":301.91781424160405},"Ottelu",null,"09.06. 2013  AA - JymyJussit  1-0  (0-0, 5-2)",{"$nulls":7},"1.  ottelu",{"$nulls":3},"  22 v   3 kk 27 pv",null,null,"Ottelu","  1.   20.08. 2017  ViVe - KiPa  2-0",{"$nulls":3},1746,null,"26 v    6 kk   7 pv"]
[null,"Ylempi loppusarja",null,null,3,0,4,1,6,null,{"$f":"PRODUCT((F26+G26)/E26)","v":{"v":1.3333333333333333,"d":"1.33"}},{"$f":"PRODUCT(H26/E26)","v":{"v":0.3333333333333333,"d":"0.33"}},{"$f":"PRODUCT(I26/E26)","v":{"v":2,"d":"2.00"}},{"v":0.5,"d":"50.0 %"},12,"Lyöty",null,"18.07. 2013  JymyJussit - AA  2-0  (3-1, 6-2)",{"$nulls":7},"5.  ottelu",{"$nulls":3},"  22 v   5 kk   5 pv",null,null,"Lyöty","  1.   20.08. 2017  ViVe - KiPa  2-0",{"$nulls":3},1746,null,"26 v    6 kk   7 pv"]
[null,"Alempi loppusarja",null,null,4,0,1,0,15,null,{"$f":"PRODUCT((F27+G27)/E27)","v":0.25},{"$f":"PRODUCT(H27/E27)","v":{"v":0,"d":"0.00"}},{"$f":"PRODUCT(I27/E27)","v":3.75},{"$f":"PRODUCT(I27/O27)","v":{"v":0.625,"d":"62.5 %"}},24,"Tuotu",null,"01.08. 2013  AA - Kiri  2-0  (4-2, 1-0)",{"$nulls":7},"9.  ottelu",{"$nulls":3},"  22 v   5 kk 19 pv",null,null,"Tuotu","  1.   20.08. 2017  ViVe - KiPa  2-0",{"$nulls":3},1746,null,"26 v    6 kk   7 pv"]
[null,"KAIKKI",null,null,{"$f":"SUM(E25:E27)","v":65},{"$f":"SUM(F25:F27)","v":1},{"$f":"SUM(G25:G27)","v":30},{"$f":"SUM(H25:H27)","v":13},{"$f":"SUM(I25:I27)","v":169},null,{"$f":"PRODUCT((F28+G28)/E28)","v":{"v":0.47692307692307695,"d":"0.48"}},{"$f":"PRODUCT(H28/E28)","v":{"v":0.2,"d":"0.20"}},{"$f":"PRODUCT(I28/E28)","v":{"v":2.6,"d":"2.60"}},{"$f":"PRODUCT(I28/O28)","v":{"v":0.5001216061345869,"d":"50.0 %"}},{"$f":"SUM(O25:O27)","v":337.91781424160405},"Kunnari",null,"07.08. 2014  JymyJussit - Kiri  2-0  (7-4, 3-0)",{"$nulls":7},"53.  ottelu",{"$nulls":3},"  23 v   5 kk 25 pv",null,null,"Kunnari"]
[{"$nulls":14},{"$f":"SUM(O26:O28)","v":373.91781424160405}]
[null,"Seurat",null,"AA = Alajärven Ankkurit  (1944),  kasvattajaseura"]
[{"$nulls":3},"KoU = Koskenkorvan Urheilijat  (1945)"]
[{"$nulls":3},"HP-K = Haapajärven Pesä-Kiilat  (1990)"]
[{"$nulls":3},"Kiri = Jyväskylän Kiri  (1930)"]
[{"$nulls":3},"KiPa = Kiteen Pallo-90  (1990)"]
[{"$nulls":3},"LieKi = Lievestuoreen Kisa  (1927)"]

{"sheet":"MYP, MSS","index":1,"n_rows":18,"n_cols":45,"rows_kept":18}
[null,"Robert Tallbacka",null,null,"13.2.1991   Alajärvi"]
[null,"YKKÖSPESIS",null,null,"Runkosarja",{"$nulls":6},"    Runkosarja TOP-10",{"$nulls":4},"Jatkosarjat",{"$nulls":6},"SUOMENSARJA",null,null,"Runkosarja",{"$nulls":6},"  Runkosarja TOP-10",{"$nulls":4},"Jatkosarjat"]
[null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%"]
[null,2008,"10.","AA",10,0,3,0,15,{"v":0.375,"d":"37.5 %"},40,{"$nulls":12},2008,"3.","KoU  2",0,0,0,0,0,{"$nulls":7},3,0,0,1,3,{"v":0.4285,"d":"42.9 %"},7]
[null,2009,"8.","AA",3,0,0,0,5,{"v":0.714,"d":"71.4 %"},7,{"$nulls":12},2009,"10.","AA  2",3,0,1,2,13,{"v":0.6842,"d":"68.4 %"},19]
[null,2010,"2.","AA",13,0,13,3,34,{"v":0.557,"d":"55.7 %"},61,{"$nulls":5},1,0,1,1,4,{"v":0.5,"d":"50.0 %"},8,2010,"9.","AA  2",2,2,2,5,15,{"v":0.625,"d":"62.5 %"},24]
[null,2011,"1.","AA",9,0,3,4,24,{"v":0.558,"d":"55.8 %"},43]
[null,2013,"12.","HP-K",8,0,2,3,36,{"v":0.632,"d":"63.2 %"},57,{"$nulls":12},2013,"7.","AA  2",2,0,1,2,11,{"v":0.6875,"d":"68.8 %"},16]
[]
[null,2017,"8.","LieKi",8,1,14,2,23,{"v":0.4259,"d":"42.6 %"},54]
[null,"YHTEENSÄ",null,null,{"$f":"SUM(E4:E10)","v":51},{"$f":"SUM(F4:F10)","v":1},{"$f":"SUM(G4:G10)","v":35},{"$f":"SUM(H4:H10)","v":12},{"$f":"SUM(I4:I10)","v":137},{"$f":"PRODUCT(I11/K11)","v":{"v":0.5229007633587787,"d":"52.3 %"}},{"$f":"SUM(K4:K10)","v":262},{"$nulls":5},{"$f":"SUM(Q4:Q10)","v":1},{"$f":"SUM(R4:R10)","v":0},{"$f":"SUM(S4:S10)","v":1},{"$f":"SUM(T4:T10)","v":1},{"$f":"SUM(U4:U10)","v":4},{"$f":"PRODUCT(U11/W11)","v":{"v":0.5,"d":"50.0 %"}},{"$f":"SUM(W4:W10)","v":8},"YHTEENSÄ",null,null,{"$f":"SUM(AA4:AA10)","v":7},{"$f":"SUM(AB4:AB10)","v":2},{"$f":"SUM(AC4:AC10)","v":4},{"$f":"SUM(AD4:AD10)","v":9},{"$f":"SUM(AE4:AE10)","v":39},{"$f":"PRODUCT(AE11/AG11)","v":{"v":0.6610169491525424,"d":"66.1 %"}},{"$f":"SUM(AG4:AG10)","v":59},{"$nulls":5},{"$f":"SUM(AM4:AM10)","v":3},{"$f":"SUM(AN4:AN10)","v":0},{"$f":"SUM(AO4:AO10)","v":0},{"$f":"SUM(AP4:AP10)","v":1},{"$f":"SUM(AQ4:AQ10)","v":3},{"$f":"PRODUCT(AQ11/AS11)","v":{"v":0.42857142857142855,"d":"42.9 %"}},{"$f":"SUM(AS4:AS10)","v":7}]
[]
[null,"KAIKKI OTTELUT",null,null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"ka/L","ka/T","ka/l+t","ka/kl",null,null,"Seurat",null,"AA = Alajärven Ankkurit  (1944),  kasvattajaseura"]
[null,"SUPERPESIS",null,null,65,1,30,13,169,{"v":0.5,"d":"50.0 %"},{"$f":"PRODUCT(I14/J14)","v":338},{"$f":"PRODUCT((F14+G14)/E14)","v":{"v":0.47692307692307695,"d":"0.48"}},{"$f":"PRODUCT(H14/E14)","v":{"v":0.2,"d":"0.20"}},{"$f":"PRODUCT((F14+G14+H14)/E14)","v":{"v":0.676923076923077,"d":"0.68"}},{"$f":"PRODUCT(I14/E14)","v":{"v":2.6,"d":"2.60"}},{"$nulls":4},"KoU = Koskenkorvan Urheilijat  (1945)"]
[null,"YKKÖSPESIS",null,null,{"$f":"PRODUCT(E11+Q11)","v":52},{"$f":"PRODUCT(F11+R11)","v":1},{"$f":"PRODUCT(G11+S11)","v":36},{"$f":"PRODUCT(H11+T11)","v":13},{"$f":"PRODUCT(I11+U11)","v":141},{"$f":"PRODUCT(I15/K15)","v":{"v":0.5222222222222223,"d":"52.2 %"}},{"$f":"PRODUCT(K11+W11)","v":270},{"$f":"PRODUCT((F15+G15)/E15)","v":{"v":0.7115384615384616,"d":"0.71"}},{"$f":"PRODUCT(H15/E15)","v":0.25},{"$f":"PRODUCT((F15+G15+H15)/E15)","v":{"v":0.9615384615384616,"d":"0.96"}},{"$f":"PRODUCT(I15/E15)","v":{"v":2.7115384615384617,"d":"2.71"}},{"$nulls":4},"HP-K = Haapajärven Pesä-Kiilat  (1990)"]
[null,"SUOMENSARJA",null,null,{"$f":"PRODUCT(AA11+AM11)","v":10},{"$f":"PRODUCT(AB11+AN11)","v":2},{"$f":"PRODUCT(AC11+AO11)","v":4},{"$f":"PRODUCT(AD11+AP11)","v":10},{"$f":"PRODUCT(AE11+AQ11)","v":42},{"$f":"PRODUCT(I16/K16)","v":{"v":0.6363636363636364,"d":"63.6 %"}},{"$f":"PRODUCT(AG11+AS11)","v":66},{"$f":"PRODUCT((F16+G16)/E16)","v":{"v":0.6,"d":"0.60"}},{"$f":"PRODUCT(H16/E16)","v":{"v":1,"d":"1.00"}},{"$f":"PRODUCT((F16+G16+H16)/E16)","v":{"v":1.6,"d":"1.60"}},{"$f":"PRODUCT(I16/E16)","v":{"v":4.2,"d":"4.20"}},{"$nulls":4},"Kiri = Jyväskylän Kiri  (1930)"]
[null,"YHTEENSÄ",null,null,{"$f":"SUM(E14:E16)","v":127},{"$f":"SUM(F14:F16)","v":4},70,36,352,{"$f":"PRODUCT(I17/K17)","v":{"v":0.5222551928783383,"d":"52.2 %"}},{"$f":"SUM(K14:K16)","v":674},{"$f":"PRODUCT((F17+G17)/E17)","v":{"v":0.5826771653543307,"d":"0.58"}},{"$f":"PRODUCT(H17/E17)","v":{"v":0.28346456692913385,"d":"0.28"}},{"$f":"PRODUCT((F17+G17+H17)/E17)","v":{"v":0.8661417322834646,"d":"0.87"}},{"$f":"PRODUCT(I17/E17)","v":{"v":2.7716535433070866,"d":"2.77"}},{"$nulls":4},"KiPa = Kiteen Pallo-90  (1990)"]
[{"$nulls":19},"LieKi = Lievestuoreen Kisa  (1927)"]

{"sheet":"Kärkilyönnit","index":2,"n_rows":20,"n_cols":29,"rows_kept":20}
[null,"KÄRKILYÖNNIT RUNKOSARJASSA",{"$nulls":19},"VUOSITTAISET SIJOITUKSET  TOP - 30"]
[{"$nulls":6},"0 > 1",null,null,"1 > 2",null,null,"2 > 3",null,null,"3 > k",null,null,"Yhteensä"]
[null,"Vuosi","Sija","Seura","OTT","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%",null,"Vuosi","Sija","Seura","0 > 1","1 > 2","2 > 3","3 > k","KL"]
[null,2013,"12.","AA",11,1,2,{"v":0.5,"d":"50.0 %"},21,30,{"v":0.7,"d":"70.0 %"},13,27,{"v":0.4814,"d":"48.1 %"},4,12,{"v":0.3333,"d":"33.3 %"},39,71,{"v":0.5492957746478874,"d":"54.9 %"},null,2013,"12.","AA"]
[null,2014,"12.","Kiri",25,5,13,{"v":0.3846,"d":"38.5 %"},20,46,{"v":0.4347,"d":"43.5 %"},42,74,{"v":0.5675,"d":"56.8 %"},8,18,{"v":0.4444,"d":"44.4 %"},75,151,{"v":0.4966887417218543,"d":"49.7 %"},null,2014,"12.","Kiri",null,null,"27."]
[null,"****",{"$nulls":19},"****"]
[null,2017,"7.","KiPa",22,0,6,{"v":0,"d":"0.0 %"},7,12,{"v":0.5833,"d":"58.3 %"},13,23,{"v":0.5652,"d":"56.5 %"},14,39,{"v":0.3589,"d":"35.9 %"},34,80,{"v":0.425,"d":"42.5 %"},null,2017,"7.","KiPa"]
[null,"Yhteensä",null,null,{"$f":"SUM(E4:E7)","v":58},{"$f":"SUM(F4:F7)","v":6},{"$f":"SUM(G4:G7)","v":21},{"$f":"PRODUCT(F8/G8)","v":{"v":0.2857142857142857,"d":"28.6 %"}},{"$f":"SUM(I4:I7)","v":48},{"$f":"SUM(J4:J7)","v":88},{"$f":"PRODUCT(I8/J8)","v":{"v":0.5454545454545454,"d":"54.5 %"}},{"$f":"SUM(L4:L7)","v":68},{"$f":"SUM(M4:M7)","v":124},{"$f":"PRODUCT(L8/M8)","v":{"v":0.5483870967741935,"d":"54.8 %"}},{"$f":"SUM(O4:O7)","v":26},{"$f":"SUM(P4:P7)","v":69},{"$f":"PRODUCT(O8/P8)","v":{"v":0.37681159420289856,"d":"37.7 %"}},{"$f":"SUM(R4:R7)","v":148},{"$f":"SUM(S4:S7)","v":302},{"$f":"PRODUCT(R8/S8)","v":{"v":0.4900662251655629,"d":"49.0 %"}}]
[]
[null,"KÄRKILYÖNNIT YLEMMISSÄ PUDOTUSPELEISSÄ",{"$nulls":19},"VUOSITTAISET SIJOITUKSET  TOP - 30"]
[{"$nulls":6},"0 > 1",null,null,"1 > 2",null,null,"2 > 3",null,null,"3 > k",null,null,"Yhteensä"]
[null,"Vuosi","Sija","Seura","OTT","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%",null,"Vuosi","Sija","Seura","0 > 1","1 > 2","2 > 3","3 > k","KL"]
[null,2017,"7.","KiPa",3,0,0,{"v":0,"d":"0.0 %"},0,1,{"v":0,"d":"0.0 %"},2,3,{"v":0.6666,"d":"66.7 %"},4,8,{"v":0.5,"d":"50.0 %"},6,12,{"v":0.5,"d":"50.0 %"},null,2017,"7.","KiPa",{"$nulls":3},"20."]
[null,"Yhteensä",null,null,{"$f":"SUM(E11:E13)","v":3},{"$f":"SUM(F13:F13)","v":0},{"$f":"SUM(G13:G13)","v":0},{"v":0,"d":"0.0 %"},{"$f":"SUM(I13:I13)","v":0},{"$f":"SUM(J13:J13)","v":1},{"$f":"PRODUCT(I14/J14)","v":{"v":0,"d":"0.0 %"}},{"$f":"SUM(L13:L13)","v":2},{"$f":"SUM(M13:M13)","v":3},{"$f":"PRODUCT(L14/M14)","v":{"v":0.6666666666666666,"d":"66.7 %"}},{"$f":"SUM(O13:O13)","v":4},{"$f":"SUM(P13:P13)","v":8},{"$f":"PRODUCT(O14/P14)","v":{"v":0.5,"d":"50.0 %"}},{"$f":"SUM(R13:R13)","v":6},{"$f":"SUM(S13:S13)","v":12},{"$f":"PRODUCT(R14/S14)","v":{"v":0.5,"d":"50.0 %"}}]
[]
[null,"KÄRKILYÖNNIT "]
[{"$nulls":6},"0 > 1",null,null,"1 > 2",null,null,"2 > 3",null,null,"3 > k",null,null,"Yhteensä"]
[{"$nulls":4},"OTT","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%"]
[null,"RUNKOSARJA",null,null,{"$f":"PRODUCT(E8)","v":58},{"$f":"PRODUCT(F8)","v":6},{"$f":"PRODUCT(G8)","v":21},{"$f":"PRODUCT(H8)","v":{"v":0.2857142857142857,"d":"28.6 %"}},{"$f":"PRODUCT(I8)","v":48},{"$f":"PRODUCT(J8)","v":88},{"$f":"PRODUCT(K8)","v":{"v":0.5454545454545454,"d":"54.5 %"}},{"$f":"PRODUCT(L8)","v":68},{"$f":"PRODUCT(M8)","v":124},{"$f":"PRODUCT(N8)","v":{"v":0.5483870967741935,"d":"54.8 %"}},{"$f":"PRODUCT(O8)","v":26},{"$f":"PRODUCT(P8)","v":69},{"$f":"PRODUCT(Q8)","v":{"v":0.37681159420289856,"d":"37.7 %"}},{"$f":"PRODUCT(R8)","v":148},{"$f":"PRODUCT(S8)","v":302},{"$f":"PRODUCT(T8)","v":{"v":0.4900662251655629,"d":"49.0 %"}}]
[null,"PLAY OFF",null,null,{"$f":"PRODUCT(E14)","v":3},{"$f":"PRODUCT(F14)","v":0},0,{"v":0,"d":"0.0 %"},0,1,{"v":0,"d":"0.0 %"},2,3,{"v":0.6666666666666666,"d":"66.7 %"},4,8,{"v":0.5,"d":"50.0 %"},6,12,{"v":0.5,"d":"50.0 %"}]